Investors are increasingly optimistic about the stock market, with a record low in cash levels and fund managers showing their most positive sentiment since 2021, despite concerns over tech valuations.