US-born suspected al-Qaeda leader Anwar al-Awlaki, whose death was said to have been personally ordered by President Obama, is killed by a US air strike in Yemen, reports say.