Former Brexit negotiator Sir Oliver Robbins has been appointed as the Foreign Office’s highest ranking civil servant.