The rate of prescriptions that doctors write for painkillers varies widely by state, with states in the South having some of the highest rates, according to a new report