Cole Palmer tried to leave Manchester City “for two seasons” before joining Chelsea, according to Pep Guardiola.