Unfortunately, no.
Even if you click on the last tab, "insert" is all that is available, and it inserts between the last two tabs. If you want to insert between two tabs it works fine - just click on the tab on the right of the insert position you want. Inserting from the file menu always places the tab in the first position.
Move or copy is the best method here, so if you keep a blank sheet, you can always Move or Copy (you'd want to tick the copy checkbox) it and determine its insertion point by choosing one from the list, including (move to end).
Regardless as to method, there is indeed an un-aesthetic amount of clicking or dragging.