A leading figure in Germany’s ruling Social Democratic party (SPD) has called for far closer links between the UK and the European Union, amid rising concerns the Brexit divide is harming efforts to solve international crises, including mass migration.