SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select *
into customers
from (values (1, 'Tom'), (2, 'Bob'), (3, 'Sam'), (4, 'Angel'), (5, 'Joe')) v(id, name)
5 rows affected

select * from customers

id
name

1
Tom

2
Bob

3
Sam

4
Angel

5
Joe

select Name into TestTable from Customers order by NEWID() 
       
5 rows affected

select * from TestTable

Name

Tom

Bob

Sam

Angel

Joe

select identity(int) as id, Name
into TestTable2
from Customers
order by NEWID();

5 rows affected

select *
from TestTable2
order by id;

id
Name

1
Bob

2
Sam

3
Angel

4
Tom

5
Joe