name the office holder with predecessor as herwald ramsbotham and office in under-secretary of state for foreign affairs ?
SELECT DISTINCT var_uri where brack_open var_uri dbp_predecessor dbr_Herwald_Ramsbotham,_1st_Viscount_Soulbury sep_dot var_uri dbp_office dbr_Under-Secretary_of_State_for_Foreign_Affairs sep_dot var_uri a dbo_OfficeHolder brack_close