The former defensive midfielder, who won the World Cup in 1998, was set to work under Sir Alex Ferguson at Manchester United but changed his mind