Scaling limits of stochastic transport equations on manifolds