A member of the Buckingham Palace household has resigned and apologised after repeatedly asking a British black charity boss where she was ‘really’ from.