A Buckingham Palace aide has resigned and tendered an apology over racist comments reportedly made to a black British guest…