how about just

select min(port_num)+1 from table_name
[download]

if you need the values of other columns, since this is a aggregate select statement, you'd use a "first" or "max" or similar to get the desired values from those other columns. in other words if you use any aggregate sql function on any column, you'll need to use aggregate functions on all columns, which provides a proper set of rows that makes sense.