Generating Random Numbers in SQL Server Without Collisions

From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the next identifier is not guessable, or to prevent insight into how many new users or orders are being gene