North-east MSP Lewis MacDonald reflects on 22-year career after final speech