The cost of meeting the country’s housing deficit with the construction of 500,000 homes by 2040 will exceed the current national debt, a former secretary general of the Department of Finance has warned.