From a sex, drugs and rock ’n’ roll scandal at Scottish & Newcastle to a roller-coaster ride of acquisitions at Marston’s, Stephen Oliver looks back fondly on his time in the trade