How to auto-generate unique random-looking numbers?

Currently I'm passing one value to my database, it's a random and unique 10-digit number. Is there a way I could generate this number directly in my database each time a new row is created? It looks something like this

id_Primarykey  Name  random number  
1              x     1231233592  
2              Y     5234234837  
3              Z     3453450394

Said number has to be unique, 10 digits, and random (non-sequential).