Edit the display profile for the appropriate container.
Change the startTab property to the tab to highlight when the user logs in. For example:
<String name="startTab" value="MyFrontPageTabPanelContainer"/>
Load the display profile into LDAP by using the psadmin command.