The former Manchester United manager faced off against the German side as a player and a manager in Scotland