A former army sergeant, who survived an IRA bomb blast, has stabbed his two children to death before killing himself.