Has the bear market hit the bottom? Goldman’s Oppenheimer delivers his verdict — and reveals where he sees ‘great opportunities’