A post-lockdown boom saw a Sheffield auction attract more than £3m in sales as demand outstripped supply.