Manchester United were "close" to signing Cole Palmer before his first-team breakthrough at Manchester City and eventual high-profile transfer to Chelsea.