How can i create autonumber code on laravel?

Hey i wanna make a autonumber code for my product table without using models. How should i write the code on the controller?

Example :
BRG-0001
BRG-0002.

Im not using a models, just using query builder methods. So how should i write in the controller?