England were sent packing from the Champions Trophy after a dramatic late defeat at the hands of Afghanistan.