$order = new Order; $order->user_id = Auth()->id(); $latestOrder = AppOrder::orderBy('created_at','DESC')->first(); $order->order_nr = '#'.str_pad($latestOrder->id + 1, 8, "0", STR_PAD_LEFT); $order->save();