Add offset and limit parameters to names resolver

What does this MR do?

Adds offset and limit to the branch names resolver to be used by the frontend. This will allow the frontend to efficiently query branch names in a repository. The first use-case is for the pipeline editor branch dropdown - !59217 (merged).

Related #329652 (closed)

Does this MR meet the acceptance criteria?

Conformity

• Does this MR need a changelog?
  • I have included a changelog entry.
  • N/A I have not included a changelog entry because _____.
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• N/A Database guides
• N/A Separation of EE specific content

app/finders/repositories/branch_names_finder.rb

@@ -10,9 +10,9 @@ def initialize(repository, params = {})
     end
 
     def execute
-      return unless search
+      return unless search && offset && limit
 
-      repository.search_branch_names(search)
+      repository.search_branch_names(search).lazy.drop(offset).take(limit) # rubocop:disable CodeReuse/ActiveRecord
     end
 
     private
@@ -20,5 +20,13 @@ def execute
     def search
       @params[:search].presence
     end
+
+    def offset
+      @params[:offset]
+    end
+
+    def limit
+      @params[:limit]
+    end
   end
 end