Guardiola’s luck turns to end Champions League tales of woe