Holyrood is expected to pay almost £40 million after spending during Scotland’s ‘mega-worlds’, which brought in a total revenue of £205 million, went over budget “most notably due to inflation”