Turning down Manchester United for Chelsea due to his wife's desire to avoid living up north ended up being a significant regret for the legendary midfielder