The cursor should do that by default. I believe what you want is for the new window to be created on the right (by default it is created on the left).
vim.opt.splitright = true
You might also like:
vim.opt.splitbelow = true
I use both of these options because it seems much more intuitive to me.
See also