S&P 500 in a ‘mania’ as stock-market rally overshoots, says Wall Street bear