President Donald Trump has signed an executive order to ban transgender athletes from competing in women's and girls' sports.