Trap models with vanishing drift: Scaling limits and aging regimes