Malcolm Offord’s candour about his wealth is seen as a political gaffe by some, but Brian Monteith finds it refreshing and inspiring