Index Creation Possibility with Sorted Data based on Some Field

select * 
from bucket as doc 
where doc.name = "value " where doc.type = “group” 
order by doc.lastModified desc
create index ix1ON `bucket` (name, lastModified DESC ) where type = “group”;

https://index-advisor.couchbase.com/indexadvisor/#1