US President Donald Trump says CEOs are leaving his manufacturing council 'out of embarrassment' for making products outside of the US.