It is the result of the first in-depth investigation into Scotland’s total housing need in the last 10 years.