The former England defender believes nobody at Manchester City would have foreseen Palmer's rise to the top