Yes, it increased consumption by creating new addicts. Because, as with cigarettes, addicts are good customers. But it was inability to keep getting prescriptions that caused overdoses and death. Because you had all these ~middle class addicts switching to heroin, without a clue how to use illicit heroin at least somewhat safely. That, and the increasing use of fentanyl to increase potency of highly cut heroin.