The number of foreign direct investment (FDI) projects secured by Scotland rose to a record 124 in 2023 – a 12.7% rise on the previous year.