The Foreign Office’s most senior civil servant Sir Olly Robbins is to leave his role following revelations that the department overruled security vetting for Lord Peter Mandelson's appointment as UK ambassador to the US.