Around 120,000 working-age Scots have never worked a day in their lives, shocking figures show.