At least nine people are killed in an al-Qaeda attack on a checkpoint in the southern Yemeni city of Aden, police say.