New figures reveal 'evidence of devastating impact' caused by the SNP administration’s bungled housing policy