Colin Farquhar: Gray’s School of Art show holds a mirror to Aberdeen at a turning point in oil and gas