The Scottish Government has substantially reduced the value of £140 million-worth of loans and guarantees to private companies, says the public spending watchdog.