A UK soldier has been killed during a dramatic raid to rescue a kidnapped journalist in Afghanistan, the Ministry of Defence has confirmed.