SAS sniper, who was first British soldier to die fighting Isil, was killed by friendly fire