Simulating quantum many-body physics on quantum and classical computers