Donald Trump said he was dropping the tariff "in honour" of the King and Queen following their visit to the US.