Manchester City will face Real Madrid or Bayern Munich after edging into the Champions League play-offs with a fightback versus Club Brugge.