Manchester City boss Pep Guardiola says his side “were so close” to reaching the Champions League final after conceding three late goals to Real Madrid and losing 6-5 on aggregate in their semi-final.