Major official study suggests rising numbers see property as the best bet for retirement, with pensioners now able to cash in their savings to invest