Does public ranking motivate learners, or create stress?

Leaderboards and class rankings are everywhere but do they actually help people learn, or do they just add pressure?

Curious what others think, especially teachers and students who've experienced both sides.