England were knocked out of the Champions Trophy after losing to Afghanistan in Lahore.