Legal drugs such as prescription medication, alcohol, and methadone are responsible for most drug overdoses, according to new figures.