President Trump has signed an executive order in support of research into whether psychedelic drugs could be used in mental health treatments.