Health professionals have said that the 'sudden collapse' overdoses have occurred immediately upon injection come amid similar cases across Scotland.