The UN condemns as "heinous" a suicide attack in Yemen that killed more than 90 soldiers, which al-Qaeda said it carried out.