It's not a random function, but it creates a random value which is designed to be a uniqueidentifier. It will create a different value for each row (unlike RAND which needs a different seed to return different results in the same query). So when you order by it, the order becomes random.