Action must be taken to tackle Scotland's NEETs crisis, SNP ministers have been warned after a long-awaited review demanded a UK-wide overhaul.