House prices in Scotland have risen, while the average UK house price has fallen annually for the first time since 2023.