For sure, but not with a double click (with standard settings, which can be changed if you want).
You can for example open a folder in a new tab via context menu or you create first a new tab and open the second folder there. Or you define that with double middle click on a folder it is opened in a new tab (not sure if that is a standard setting).
See also e.g. Middle click folder to open in new folder tab
Is that want you want/mean?