US President Donald Trump has issued an executive order that bans transgender women from competing in female sport.