A man who missed his regular pharmacy visit to collect prescribed methadone was later found dead from a drugs overdose, an inquest has heard.