Lazy loading with query builder in Laravel

Question

I have a large table (100K +) records and I am using datatables and Yarja.

My query starts with

$gp = DB::table('GoogleProspects')
            ->orderBy('id')
            ->whereNull('deleted_at')
            ->select([
                'GoogleProspects.id as id',
                'searchRequest as searchRequest',
                'websiteEmail as websiteEmail',
                'websiteHomePageURL as websiteHomePageURL',
                'websitePhoneNr as websitePhoneNr',
                'active as activeFlag'
            ])
            ->get();

But it seems to be loading ALL the records rather than the pagination number.

Any ideas please?