Pep Guardiola delivered one of the most emotional and memorable farewell speeches in the history of English football after his final game as Man City boss.