A changed market, and changed lifestyles, but the post-Covid demand for housing in Scotland is as enduring as ever