Incorrect syntax near '0'.: EXEC sp_executesql N'SELECT [users].* FROM [users] OFFSET 0 ROWS FETCH N

I’m using rails 5.1.6 with activerecord-sqlserver-adapter 5.1.6, tiny_tds 2.1.2. and SQL Server 2017. Databaseaccess is OK,

SQL (1.1ms) USE [MIST_Test]

User Load (1.5ms) EXEC sp_executesql N’SELECT [users].* FROM [users] OFFSET 0 ROWS FETCH NEXT @0 ROWS ONLY’, N’@0 int’, @0 = 1 [[“LIMIT”, nil]]

ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near ‘0’.: EXEC sp_executesql N’SELECT [users].* FROM [users] OFFSET 0 ROWS FETCH NEXT @0 ROWS ONLY’, N’@0 int’, @0 = 1

from C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/activerecord-sqlserver-adapter-5.1.6/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `each’

Caused by TinyTds::Error: Incorrect syntax near ‘0’.

from C:/Ruby25-x64/lib/ruby/gems/2.5.0/gems/activerecord-sqlserver-adapter-5.1.6/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `each’

SQL Server needs an ‘ORDER BY’ to use the ‘OFFSET’ clause.

Can somebody help?