Yeah, open the Downloads page (from the Opera menu), then click on the View button in the top-right corner. First 3 items determine what happens when you start a download - first option brings it to the front, second option (my default) open it but leaves it in the background, and the third option doesn't open it at all. Take your pick.