Gray apologised to MSPs on Thursday for using a Scottish Government car to attend matches involving Aberdeen FC, the team he supports.