The Ministry of Defence (MoD) has been issued with a Crown Censure by the Health and Safety Executive (HSE) after a soldier died when he was shot in the neck on a training exercise.