England are dumped out of the Champions Trophy by a nerve-shredding eight-run defeat by Afghanistan in Lahore.