One of Britain’s highest ranking Royal Marines has branded the cold-blooded execution of an injured Afghan insurgent as “truly shocking and appalling”.