James Roscoe stood in as interim ambassador after Lord Peter Mandelson was sacked but has now departed amid claims he was being investigated for leaking