In one of the most comprehensive studies to date, the findings showed more than one in ten Americans used prescription opioids