Manchester United’s new manager in waiting transformed Sporting from fallen giants to the champions of Portugal and he faces a similar task at Old Trafford