Barcelona advanced to the last four of the women's Champions League with a 4-2 aggregate victory over Manchester City.